Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
BusinessUnitID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | BusinessUnit(LO_BSN_UN) |
TankID (PK) | A unique identifier for this Tank | ID_TNK | Identity | integer | |
LocationID (FK) | A unique system assigned identifier for the Location. | ID_LCN | Identity | integer | InventoryLocation(LO_LCN_INV) |
TankDiameter | The diameter of the tank | QL_DMTR_TNK | Quantity | DECIMAL(9,3) | |
ShellCapacity | The largest volume of product that a tank can hold. | QV_CPC_SHL | Quantity | DECIMAL(9,3) | |
MaximumSafeFillCapacity | The largest capacity that the tank safely holds, taking temperature effects into consideration. | QV_CPC_MXM | Quantity | DECIMAL(9,3) | |
LowCapacity | The volume to which a tank may be emptied without prumping vapour into the line. The amount of product that just reaches the entrance of the suction pipe. | QV_CPC_LW | Quantity | DECIMAL(9,3) | |
HighLevelSetPoint | The level at which the TankLevelGauge will set off the 'High Level Alarm'. | QL_LV_HGH | Quantity | DECIMAL(9,3) | |
LowLevelSetPoint | The level at which the TankLevelGuage will set off the 'Low Level Alarm' | QL_LV_LW | Quantity | DECIMAL(9,3) | |
LowLowLevelSetPoint | The level at which the TankLevelGuage will set off the 'Low Low Level Alarm' This alarm is the 'I really mean it this time, and you better do something real soon Low Level Alarm' | QL_LV_LW_LW | Quantity | DECIMAL(9,3) | |
HighWaterSetPoint | The level at which the TankLevelGuage will set off the 'High Water Alarm' | QL_LV_WTR_HGH | Quantity | DECIMAL(9,3) | |
StrapLevel | The Strap Level Height (a technical term) | QL_LV_STRP | Quantity | DECIMAL(9,3) | |
StrapVolume | The volume of product stored in the Tank when the height reading is equal to the StrapLevel | QV_STRP | Quantity | DECIMAL(9,3) | |